ALTER VIEW [dbo].[LocalSchemaVersion] AS
SELECT 5 AS VersionNumber
GO

CREATE TABLE DranetzWaveformCheckpoint
(
    ID INT IDENTITY(1, 1) NOT NULL PRIMARY KEY,
    Device VARCHAR(200) NOT NULL UNIQUE,
    TimeRecorded DATETIME2 NOT NULL
)
GO

CREATE TABLE DranetzTrendingCheckpoint
(
    ID INT IDENTITY(1, 1) NOT NULL PRIMARY KEY,
    Device VARCHAR(200) NOT NULL UNIQUE,
    TimeRecorded DATETIME NOT NULL
)
GO